<body>
<space name="user">
    <query name="add" type="sql">
        <content>
            <![CDATA[
            insert into demo(id,name,mark)
            values(:id,:name,:mark)
            ]]>
        </content>
    </query>

    <query name="queryList" type="sql">
        <resultList>
            <result column="id" type="string"/>
            <result column="name" type="string"/>
            <result column="account" type="string"/>
            <result column="password" type="string"/>
            <result column="nickname" type="string"/>
        </resultList>
        <content>
            <![CDATA[
            select
            u.id id,
            u.name name,
            u.account account,
            u.password password,
            u.nickname nickname
            from m_user u
            where 1=1
            <#if name?? && ''!=name>
                and u.name like %:name%
            </#if>
            <#if outIds?? && ''!=outIds>
                and u.id not in( :outIds )
            </#if>
            order by id
            ]]>
        </content>
    </query>
</space>
</body>
